I've been scouring the Notes help documentation and forums on the web for several days now trying to determine if Notes will look up a field to determine if it is unique. I found this code snippet in the Notes 5 forum and made a few small changes to it for my application. However, while the first part of the code works and I get an error message if the field is empty, the second part where the value is compared against existing values to determine that it is indeed unique, I never get an error. Does anyone have any insight? Many thanks!
@If(RequestNo = "";
@Failure("You have to enter a Req Number");
@DbLookup("":"NoCache"; "" : "" ; "All Reqs"; RequestNo; "RequestNo"));
@IsNewDoc = 0;
@Failure("This Req Number Already Exists."))
Here's a link to the original posting: http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/dbe549cbd7b7921b85256a3700496de7?OpenDocument
Again, thanks for helping!